2016-10-13 - 28031 - Break Fix - Sales Analysis-Financials WEBI creation #WEBI
BREAK FIX
28031.100 - Sales Analysis/Financials WEBI creation
Problem Summary
Need to fix bucket dimension values outside of specified ranking into "All Others"
.
Admin Info
Purpose
|
Need to fix bucket dimension values outside of specified ranking into "All Others".
|
Requested by
|
Jayson Osmars
|
Issue Date
|
10/13/2016
|
Resolved by
|
Dhananjay G
|
Resolved Date
|
12/31/2016
|
Document Status
|
Complete
|
Detailed Problem Description
IM From Jayson on 10/13/2016:
The business users want to rank the tables to top 10. Every dimension value outside the top 10 needs to be be a bucket of "All Others".
Solution Analysis and Recommendation
1. Need to create bucket dimension values outside of specified ranking into "All Others" for NA region.
2. Need to add “All Others” section to Category table in Sales Analysis WEBI report
.
3. Need to validate the reports with BW BEx query.
4. Need to place the report in BI development and inform NEC for promotion after successful validation.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC standard checklist.
|
2
|
Execute WEBI Report in Web Intelligence tool after changes.
|
Report should execute successfully in Web Intelligence.
|
3
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
Resolution
1. Completed the required changes for adding “All Others” section to Category table in Sales Analysis WEBI report for North America region.
2. Placed the WEBI report in BI development and informed NEC for validation.
Release Information
Waiting to confirm the changes. Once these changes approved then we will replicate the same changes to remaining tables like Customer, Silhouette, Market Segment etc.